
package queryTabel;

/**
 *
 * @author admin
 */
public class Query {
    
//Tabel UserSekolah :
//CREATE TABLE USERSEKOLAH (
//USERNAME VARCHAR2(20) NOT NULL , 
//PASSWORD VARCHAR2(20) NOT NULL, 
//CONSTRAINT USERSEKOLAH_PK PRIMARY KEY (USERNAME) ENABLE);

    
//Tabel Sekolah :
//CREATE TABLE SEKOLAH (
//NOSEKOLAH NUMBER(20, 0) NOT NULL, 
//NAMASEKOLAH VARCHAR2(30) NOT NULL, 
//ALAMAT VARCHAR2(50) NOT NULL, 
//EMAIL VARCHAR2(20) NOT NULL, 
//KUOTA NUMBER(5, 0) NOT NULL, 
//USERNAME VARCHAR2(10) NOT NULL, 
//CONSTRAINT SEKOLAH_PK PRIMARY KEY (NOSEKOLAH) ENABLE );
//
//ALTER TABLE SEKOLAH
//ADD CONSTRAINT SEKOLAH_USERSEKOLAH_FK1 FOREIGN KEY
//(USERNAME) REFERENCES USERSEKOLAH(USERNAME) ENABLE;
//
//    
//Tabel CalonSiswa :
//CREATE TABLE CALONSISWA (
//NOPENDAFTARAN NUMBER(5, 0) NOT NULL, 
//NOUJIAN NUMBER(20, 0) NOT NULL, 
//NAMA VARCHAR2(50) NOT NULL, 
//TGLLAHIR DATE NOT NULL, 
//SEKOLAHASAL VARCHAR2(30) NOT NULL, 
//NILAITOTAL NUMBER(5, 0) NOT NULL, 
//PILIHAN1 VARCHAR2(30) NOT NULL, 
//PILIHAN2 VARCHAR2(30), 
//STATUSTERIMA VARCHAR2(10), 
//SEKOLAHDITERIMA VARCHAR2(30),
//CONSTRAINT CALONSISWA_PK PRIMARY KEY (NOPENDAFTARAN)
//ENABLE );

    
}
